Lotus 123 Level 3

Outcomes

Participants will learn how to create decision-making formulas, macros, versions, and custom SmartIcon sets. Students enrolling in this course should understand the basic concepts of working with 1-2-3 worksheets. For example, they should be familiar with data types (labels and values), copying data, basic formulas and functions, and opening and saving files.

Prerequisites

Windows 95: Introduction
1-2-3 Millennium Edition: Worksheets (Windows 95), or equivalent knowledge

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Advanced formula construction Range names The @ROUND function The @IF function The @VLOOKUP function Advanced worksheet management Viewing options Hiding columns of a worksheet Protecting worksheet data Using 3-D workbooks and linking multiple files Using 3-D workbooks Working with multiple files Comparing multiple worksheet files and linked files Analyzing information The @ISERR function Using the Backsolver feature Outlining

Creating versions Creating version groups and version reports Introduction to macros and LotusScript Introduction to macros Introduction to LotusScript Enhancing and printing worksheets Filling and transposing ranges Enhancing worksheet appearance Advanced printing techniques Customizing the SmartIcon bar; using Internet tools Working with sets of SmartIcons Customizing a SmartIcon set Internet tools

Performance-based objectives

• Create decision-making formulas by using range names and advanced functions
• Display and protect worksheet data by hiding and displaying columns and protecting cells
• Summarize data from several workbooks by creating and modifying formulas that link workbook files
• Troubleshoot and analyze data by using the @ISERR function and the Backsolver
• Analyze information by substituting different sets of data into specified ranges by using versions and version groups
• Automate repetitive tasks by creating and running macros and scripts
• Enhance a worksheet's appearance by using designer frames and style templates, and print large worksheets by using print titles and changing the page orientation
• Customize the 1-2-3 work area by modifying an existing SmartIcon set and creating a customized SmartIcon set; and work with the Internet by using built-in Internet tools